﻿/****** Object:  Table [dbo].[WS_CommonItems]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WS_CommonItems](
	[sLangID] [varchar](50) NOT NULL,
	[sCommonNO] [varchar](18) NOT NULL,
	[sComID] [varchar](8) NOT NULL,
	[sComDesc] [varchar](40) NOT NULL,
	[nNum1] [numeric](16, 2) NULL,
	[sText1] [varchar](40) NULL,
	[nTag] [int] NOT NULL,
	[sCreateUser] [varchar](20) NOT NULL,
	[dCreateDate] [datetime] NOT NULL,
	[sChangeUser] [varchar](20) NOT NULL,
	[dChangeDate] [datetime] NOT NULL,
	[sConfirmUser] [varchar](20) NULL,
	[dConfirmDate] [datetime] NULL,
	[dLastUpdateTime] [datetime] NOT NULL,
	[sMemo] [varchar](255) NULL,
	[nOrder] [int] NULL,
 CONSTRAINT [PK_WS_CommonItems_1] PRIMARY KEY CLUSTERED 
(
	[sCommonNO] ASC,
	[sComID] ASC,
	[sLangID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_SmartQueryParams]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_SmartQueryParams](
	[QueryName] [varchar](30) NOT NULL,
	[ParamID] [int] NOT NULL,
	[ParamName] [varchar](20) NOT NULL,
	[ParamType] [varchar](20) NOT NULL,
	[DisplayLabel] [varchar](20) NULL,
	[DefaultValue] [varchar](20) NULL,
	[SQL] [varchar](255) NULL,
	[PickList] [varchar](255) NULL,
	[Groups] [varchar](255) NULL,
	[BlockTo] [varchar](255) NULL,
	[Validator] [varchar](255) NULL,
	[HintText] [varchar](255) NULL,
	[Tag] [int] NULL,
 CONSTRAINT [PK_STDQUERYPARAMS] PRIMARY KEY CLUSTERED 
(
	[QueryName] ASC,
	[ParamID] ASC,
	[ParamName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_SmartQueryChecks]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_SmartQueryChecks](
	[QueryName] [varchar](30) NOT NULL,
	[Idx] [int] NOT NULL,
	[Summary] [varchar](255) NULL,
	[ValidateType] [varchar](20) NULL,
	[CompareType] [varchar](20) NULL,
	[MaximumValue] [varchar](40) NULL,
	[MinimumValue] [varchar](40) NULL,
	[ParamToValidate] [varchar](30) NULL,
	[ParamToCompare] [varchar](30) NULL,
	[SQL] [text] NULL,
	[Enabled] [bit] NOT NULL,
	[ParamToRepeat] [varchar](30) NULL,
	[CheckType] [int] NULL,
	[CheckName] [varchar](40) NULL,
 CONSTRAINT [PK_WF_SmartQueryCHECKS] PRIMARY KEY NONCLUSTERED 
(
	[QueryName] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_SmartQuery]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_SmartQuery](
	[ModelName] [varchar](40) NOT NULL,
	[ProcedureName] [varchar](40) NULL,
	[ParentModel] [varchar](20) NULL,
	[SQL] [text] NULL,
	[SumFields] [varchar](255) NULL,
	[FixCount] [int] NULL,
	[AutoExec] [int] NULL,
	[HideFields] [varchar](255) NOT NULL,
	[SumSQL] [text] NULL,
	[QueryName] [varchar](30) NOT NULL,
	[ChartSetting] [text] NULL,
	[JumpModules] [varchar](255) NULL,
	[SubQuery] [text] NULL,
	[GroupFields] [varchar](60) NULL,
	[GroupsOpened] [int] NULL,
	[HintQuerys] [text] NULL,
	[PowerColumns] [text] NULL,
	[ColumnStyles] [varchar](1000) NULL,
	[Memo] [text] NULL,
	[Property] [int] NULL,
	[InCharts] [text] NULL,
	[Context] [varchar](255) NULL,
	[PrepareScripts] [varchar](50) NULL,
	[BeforeQueryScripts] [varchar](50) NULL,
	[AfterQueryScripts] [varchar](50) NULL,
 CONSTRAINT [t_frm_StdQ_8480030211] PRIMARY KEY CLUSTERED 
(
	[QueryName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataLinkItems]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataLinkItems](
	[WrapperName] [varchar](20) NOT NULL,
	[DataObject] [varchar](20) NULL,
	[KeyField] [varchar](200) NULL,
	[LookupField] [varchar](255) NOT NULL,
	[StdQuery] [varchar](20) NULL,
	[SumFlag] [smallint] NULL,
	[FieldMatchStr] [varchar](255) NULL,
 CONSTRAINT [DataWrappe_6636734121] PRIMARY KEY CLUSTERED 
(
	[WrapperName] ASC,
	[LookupField] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_frm_DataWrapper]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_frm_DataWrapper](
	[WrapperName] [varchar](20) NOT NULL,
	[ModuleID] [varchar](12) NULL,
 CONSTRAINT [PK_T_FRM_DATAWRAPPER] PRIMARY KEY CLUSTERED 
(
	[WrapperName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataObjectSQL]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataObjectSQL](
	[ObjectName] [varchar](20) NOT NULL,
	[Idx] [smallint] NOT NULL,
	[SQL] [text] NOT NULL,
	[Firmware] [varchar](20) NULL,
 CONSTRAINT [DataObject_20271542671] PRIMARY KEY CLUSTERED 
(
	[ObjectName] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataObjectParams]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataObjectParams](
	[ObjectName] [varchar](20) NOT NULL,
	[Idx] [smallint] NOT NULL,
	[ParamName] [varchar](20) NULL,
	[ParamType] [varchar](12) NULL,
 CONSTRAINT [DataObject_20591543811] PRIMARY KEY CLUSTERED 
(
	[ObjectName] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataObjectFields]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataObjectFields](
	[ObjectName] [varchar](20) NOT NULL,
	[FieldName] [varchar](40) NOT NULL,
	[DefaultValue] [varchar](40) NULL,
 CONSTRAINT [t_frm_Data_3721933451] PRIMARY KEY CLUSTERED 
(
	[ObjectName] ASC,
	[FieldName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataObject]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataObject](
	[ObjectName] [varchar](20) NOT NULL,
	[ObjectDescription] [text] NOT NULL,
	[RelativeTables] [varchar](255) NULL,
 CONSTRAINT [DataObject_19951541531] PRIMARY KEY CLUSTERED 
(
	[ObjectName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_DataDictionary]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_DataDictionary](
	[FieldName] [varchar](40) NOT NULL,
	[Context] [varchar](40) NOT NULL,
	[DisplayLabel] [varchar](40) NULL,
	[DisplayFormat] [varchar](40) NULL,
	[DisplayWidth] [int] NOT NULL,
	[EditFormat] [varchar](40) NULL,
	[MaxValue] [int] NOT NULL,
	[MinValue] [int] NOT NULL,
	[CommonStrTypeID] [varchar](40) NULL,
	[ValidCharsType] [varchar](10) NULL,
 CONSTRAINT [DataDictio_18031534691] PRIMARY KEY CLUSTERED 
(
	[FieldName] ASC,
	[Context] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessProcs]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessProcs](
	[BusinessID] [varchar](30) NOT NULL,
	[Idx] [smallint] NOT NULL,
	[Summary] [varchar](255) NULL,
	[SQL] [text] NOT NULL,
	[Repeated] [bit] NOT NULL,
	[ExpectedRows] [int] NOT NULL,
	[InterActive] [bit] NOT NULL,
	[AffectedParam] [varchar](20) NULL,
	[NeedAuthentication] [bit] NOT NULL,
	[Enabled] [bit] NOT NULL,
	[BusinessProcID] [varchar](20) NULL,
 CONSTRAINT [BusinessPr_1836717021] PRIMARY KEY CLUSTERED 
(
	[BusinessID] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessParams]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessParams](
	[BusinessID] [varchar](30) NOT NULL,
	[Idx] [int] NOT NULL,
	[ParamName] [varchar](30) NULL,
	[Putout] [bit] NOT NULL,
	[ParamType] [varchar](20) NULL,
	[Repeated] [bit] NOT NULL,
 CONSTRAINT [PK_WF_BusinessParams] PRIMARY KEY CLUSTERED 
(
	[BusinessID] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessMacroDetailParam]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessMacroDetailParam](
	[MacroNO] [int] NOT NULL,
	[Ord] [smallint] NOT NULL,
	[ParamName] [varchar](40) NOT NULL,
	[ParamValue] [varchar](255) NULL,
	[ParamValueIndex] [smallint] NOT NULL,
 CONSTRAINT [t_frm_Busi_13391487851] PRIMARY KEY CLUSTERED 
(
	[MacroNO] ASC,
	[Ord] ASC,
	[ParamName] ASC,
	[ParamValueIndex] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessMacroDetail]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessMacroDetail](
	[MacroNO] [int] NOT NULL,
	[Ord] [int] NOT NULL,
	[BusinessID] [varchar](40) NULL,
	[ExecuteState] [smallint] NULL,
	[ErrMsg] [varchar](255) NULL,
 CONSTRAINT [t_frm_Busi_12911486141] PRIMARY KEY CLUSTERED 
(
	[MacroNO] ASC,
	[Ord] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessMacro]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessMacro](
	[MacroName] [varchar](1) NULL,
	[MacroState] [smallint] NOT NULL,
	[MacroNO] [int] NOT NULL,
	[StartTime] [datetime] NULL,
	[EndTime] [datetime] NULL,
 CONSTRAINT [t_frm_Busi_12591485001] PRIMARY KEY CLUSTERED 
(
	[MacroNO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_BusinessChecks]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_BusinessChecks](
	[BusinessID] [varchar](30) NOT NULL,
	[Idx] [int] NOT NULL,
	[Summary] [varchar](255) NULL,
	[ValidateType] [varchar](20) NULL,
	[CompareType] [varchar](20) NULL,
	[MaximumValue] [varchar](40) NULL,
	[MinimumValue] [varchar](40) NULL,
	[ParamToValidate] [varchar](20) NULL,
	[ParamToCompare] [varchar](20) NULL,
	[SQL] [text] NOT NULL,
	[Enabled] [bit] NOT NULL,
	[Summary_900] [varchar](255) NULL,
	[ParamToRepeat] [varchar](20) NULL,
	[CheckType] [smallint] NULL,
	[CheckName] [varchar](40) NULL,
 CONSTRAINT [BusinessCh_3116721581] PRIMARY KEY CLUSTERED 
(
	[BusinessID] ASC,
	[Idx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WF_Business]    Script Date: 01/15/2012 23:55:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WF_Business](
	[BusinessID] [varchar](30) NOT NULL,
	[BusinessDesc] [text] NOT NULL,
	[NeedTranscation] [bit] NULL,
	[BusinessName] [varchar](40) NULL,
	[RelativeTables] [varchar](255) NULL,
	[Property] [int] NULL,
 CONSTRAINT [Busines76710751] PRIMARY KEY CLUSTERED 
(
	[BusinessID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Default [DF__t_frm_Bus__Busin__63EEA865]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_Business] ADD  CONSTRAINT [DF__t_frm_Bus__Busin__63EEA865]  DEFAULT ('') FOR [BusinessDesc]
GO
/****** Object:  Default [DF__t_frm_Bus__Busin__64E2CC9E]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_Business] ADD  CONSTRAINT [DF__t_frm_Bus__Busin__64E2CC9E]  DEFAULT ('') FOR [BusinessName]
GO
/****** Object:  Default [DF__t_frm_Bus__Relat__65D6F0D7]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_Business] ADD  CONSTRAINT [DF__t_frm_Bus__Relat__65D6F0D7]  DEFAULT ('') FOR [RelativeTables]
GO
/****** Object:  Default [DF__t_frm_Bus__Summa__68B35D82]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Summa__68B35D82]  DEFAULT ('') FOR [Summary]
GO
/****** Object:  Default [DF__t_frm_Bus__Valid__69A781BB]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Valid__69A781BB]  DEFAULT ('Required') FOR [ValidateType]
GO
/****** Object:  Default [DF__t_frm_Bus__Compa__6A9BA5F4]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Compa__6A9BA5F4]  DEFAULT ('Equal') FOR [CompareType]
GO
/****** Object:  Default [DF__t_frm_Bus__Maxim__6B8FCA2D]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Maxim__6B8FCA2D]  DEFAULT ('') FOR [MaximumValue]
GO
/****** Object:  Default [DF__t_frm_Bus__Minim__6C83EE66]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Minim__6C83EE66]  DEFAULT ('') FOR [MinimumValue]
GO
/****** Object:  Default [DF__t_frm_Bus__Param__6D78129F]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Param__6D78129F]  DEFAULT ('') FOR [ParamToValidate]
GO
/****** Object:  Default [DF__t_frm_Bus__Param__6E6C36D8]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Param__6E6C36D8]  DEFAULT ('') FOR [ParamToCompare]
GO
/****** Object:  Default [DF__t_frm_Busin__SQL__6F605B11]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Busin__SQL__6F605B11]  DEFAULT ('') FOR [SQL]
GO
/****** Object:  Default [DF__t_frm_Bus__Enabl__70547F4A]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Enabl__70547F4A]  DEFAULT ((1)) FOR [Enabled]
GO
/****** Object:  Default [DF__t_frm_Bus__Check__7148A383]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessChecks] ADD  CONSTRAINT [DF__t_frm_Bus__Check__7148A383]  DEFAULT ('') FOR [CheckName]
GO
/****** Object:  Default [DF__t_frm_Bus__Param__77F5A112]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessMacroDetailParam] ADD  CONSTRAINT [DF__t_frm_Bus__Param__77F5A112]  DEFAULT ((0)) FOR [ParamValueIndex]
GO
/****** Object:  Default [DF__t_frm_Busin__SQL__7EA29EA1]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Busin__SQL__7EA29EA1]  DEFAULT ('') FOR [SQL]
GO
/****** Object:  Default [DF__t_frm_Bus__Repea__7F96C2DA]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Repea__7F96C2DA]  DEFAULT ((0)) FOR [Repeated]
GO
/****** Object:  Default [DF__t_frm_Bus__Expec__008AE713]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Expec__008AE713]  DEFAULT ((0)) FOR [ExpectedRows]
GO
/****** Object:  Default [DF__t_frm_Bus__Inter__017F0B4C]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Inter__017F0B4C]  DEFAULT ((0)) FOR [InterActive]
GO
/****** Object:  Default [DF__t_frm_Bus__Affec__02732F85]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Affec__02732F85]  DEFAULT ('') FOR [AffectedParam]
GO
/****** Object:  Default [DF__t_frm_Bus__NeedA__036753BE]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__NeedA__036753BE]  DEFAULT ((0)) FOR [NeedAuthentication]
GO
/****** Object:  Default [DF__t_frm_Bus__Enabl__045B77F7]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Enabl__045B77F7]  DEFAULT ((1)) FOR [Enabled]
GO
/****** Object:  Default [DF__t_frm_Bus__Busin__054F9C30]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_BusinessProcs] ADD  CONSTRAINT [DF__t_frm_Bus__Busin__054F9C30]  DEFAULT ('') FOR [BusinessProcID]
GO
/****** Object:  Default [DF__t_frm_Dat__Field__11B57315]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Field__11B57315]  DEFAULT ('') FOR [FieldName]
GO
/****** Object:  Default [DF__t_frm_Dat__Conte__12A9974E]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Conte__12A9974E]  DEFAULT ('') FOR [Context]
GO
/****** Object:  Default [DF__t_frm_Dat__Displ__139DBB87]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Displ__139DBB87]  DEFAULT ('') FOR [DisplayLabel]
GO
/****** Object:  Default [DF__t_frm_Dat__Displ__1491DFC0]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Displ__1491DFC0]  DEFAULT ('') FOR [DisplayFormat]
GO
/****** Object:  Default [DF__t_frm_Dat__Displ__158603F9]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Displ__158603F9]  DEFAULT ((0)) FOR [DisplayWidth]
GO
/****** Object:  Default [DF__t_frm_Dat__EditF__167A2832]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__EditF__167A2832]  DEFAULT ('') FOR [EditFormat]
GO
/****** Object:  Default [DF__t_frm_Dat__MaxVa__176E4C6B]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__MaxVa__176E4C6B]  DEFAULT ((0)) FOR [MaxValue]
GO
/****** Object:  Default [DF__t_frm_Dat__MinVa__186270A4]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__MinVa__186270A4]  DEFAULT ((0)) FOR [MinValue]
GO
/****** Object:  Default [DF__t_frm_Dat__Commo__195694DD]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataDictionary] ADD  CONSTRAINT [DF__t_frm_Dat__Commo__195694DD]  DEFAULT ('') FOR [CommonStrTypeID]
GO
/****** Object:  Default [DF__t_frm_Dat__Objec__1C330188]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataObject] ADD  CONSTRAINT [DF__t_frm_Dat__Objec__1C330188]  DEFAULT ('') FOR [ObjectDescription]
GO
/****** Object:  Default [DF__t_frm_Dat__Relat__1D2725C1]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataObject] ADD  CONSTRAINT [DF__t_frm_Dat__Relat__1D2725C1]  DEFAULT ('') FOR [RelativeTables]
GO
/****** Object:  Default [DF__t_frm_DataO__SQL__23D42350]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataObjectSQL] ADD  CONSTRAINT [DF__t_frm_DataO__SQL__23D42350]  DEFAULT ('') FOR [SQL]
GO
/****** Object:  Default [DF__t_frm_Dat__DataO__2898D86D]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataLinkItems] ADD  CONSTRAINT [DF__t_frm_Dat__DataO__2898D86D]  DEFAULT ('') FOR [DataObject]
GO
/****** Object:  Default [DF__t_frm_Dat__Looku__298CFCA6]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataLinkItems] ADD  CONSTRAINT [DF__t_frm_Dat__Looku__298CFCA6]  DEFAULT ('') FOR [LookupField]
GO
/****** Object:  Default [DF__t_frm_Dat__StdQu__2A8120DF]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataLinkItems] ADD  CONSTRAINT [DF__t_frm_Dat__StdQu__2A8120DF]  DEFAULT ('') FOR [StdQuery]
GO
/****** Object:  Default [DF__t_frm_Dat__SumFl__2B754518]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_DataLinkItems] ADD  CONSTRAINT [DF__t_frm_Dat__SumFl__2B754518]  DEFAULT ((0)) FOR [SumFlag]
GO
/****** Object:  Default [DF__t_frm_Std__HideF__3039FA35]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQuery] ADD  CONSTRAINT [DF__t_frm_Std__HideF__3039FA35]  DEFAULT ('') FOR [HideFields]
GO
/****** Object:  Default [DF__t_frm_Std__SumSQ__312E1E6E]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQuery] ADD  CONSTRAINT [DF__t_frm_Std__SumSQ__312E1E6E]  DEFAULT ('') FOR [SumSQL]
GO
/****** Object:  Default [DF__t_frm_Std__Query__322242A7]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQuery] ADD  CONSTRAINT [DF__t_frm_Std__Query__322242A7]  DEFAULT ('') FOR [QueryName]
GO
/****** Object:  Default [DF__t_frm_Std__Prope__5B5BC469]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQuery] ADD  CONSTRAINT [DF__t_frm_Std__Prope__5B5BC469]  DEFAULT ((0)) FOR [Property]
GO
/****** Object:  Default [DF__t_frm_Std__Valid__216BEC9A]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryChecks] ADD  CONSTRAINT [DF__t_frm_Std__Valid__216BEC9A]  DEFAULT ('Required') FOR [ValidateType]
GO
/****** Object:  Default [DF__t_frm_Std__Compa__226010D3]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryChecks] ADD  CONSTRAINT [DF__t_frm_Std__Compa__226010D3]  DEFAULT ('Equal') FOR [CompareType]
GO
/****** Object:  Default [DF__t_frm_Std__Enabl__2354350C]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryChecks] ADD  CONSTRAINT [DF__t_frm_Std__Enabl__2354350C]  DEFAULT ((1)) FOR [Enabled]
GO
/****** Object:  Default [DF__t_frm_Std__Group__34FEAF52]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryParams] ADD  CONSTRAINT [DF__t_frm_Std__Group__34FEAF52]  DEFAULT ('') FOR [Groups]
GO
/****** Object:  Default [DF__t_frm_Std__Block__35F2D38B]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryParams] ADD  CONSTRAINT [DF__t_frm_Std__Block__35F2D38B]  DEFAULT ('') FOR [BlockTo]
GO
/****** Object:  Default [DF__t_frm_Std__Valid__36E6F7C4]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WF_SmartQueryParams] ADD  CONSTRAINT [DF__t_frm_Std__Valid__36E6F7C4]  DEFAULT ('') FOR [Validator]
GO
/****** Object:  Default [DF__WS_CommonItems__sComID__70DDC3D8]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__sComID__70DDC3D8]  DEFAULT ('') FOR [sComID]
GO
/****** Object:  Default [DF__WS_CommonItems__nTag__71D1E811]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__nTag__71D1E811]  DEFAULT ((0)) FOR [nTag]
GO
/****** Object:  Default [DF__WS_CommonItems__sCreate__72C60C4A]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__sCreate__72C60C4A]  DEFAULT ('') FOR [sCreateUser]
GO
/****** Object:  Default [DF__WS_CommonItems__dCreate__73BA3083]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__dCreate__73BA3083]  DEFAULT (getdate()) FOR [dCreateDate]
GO
/****** Object:  Default [DF__WS_CommonItems__sChange__74AE54BC]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__sChange__74AE54BC]  DEFAULT ('') FOR [sChangeUser]
GO
/****** Object:  Default [DF__WS_CommonItems__dChange__75A278F5]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__dChange__75A278F5]  DEFAULT (getdate()) FOR [dChangeDate]
GO
/****** Object:  Default [DF__WS_CommonItems__dLastUp__76969D2E]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF__WS_CommonItems__dLastUp__76969D2E]  DEFAULT (getdate()) FOR [dLastUpdateTime]
GO
/****** Object:  Default [DF_WS_CommonItems_nOrder]    Script Date: 01/15/2012 23:55:57 ******/
ALTER TABLE [dbo].[WS_CommonItems] ADD  CONSTRAINT [DF_WS_CommonItems_nOrder]  DEFAULT ((0)) FOR [nOrder]
GO
